Title: SQL W3S (By-BKK) / 010 Insert INTO
Tags: Obsidian_to_Anki

Q: What does the SQL INSERT INTO statement do?
A: Adds new records to a table

Q: True/False: You can insert values into all columns without naming them
A: True

Q: What is the syntax for inserting values into specified columns?
A: INSERT INTO table_name (column1, column2) VALUES (value1, value2);

Q: How do you insert a record into all columns?
A: INSERT INTO table_name VALUES (value1, value2, …);

Q: Why don't you need to insert a value for an auto-increment ID field?
A: The value is generated automatically

Q: How do you insert data only into specific columns?
A: List the columns after INSERT INTO, followed by VALUES for those columns

Q: True/False: You can insert multiple rows in one INSERT INTO statement
A: True

Q: What is the syntax for inserting multiple rows at once?
A: INSERT INTO table_name (columns) VALUES (value1, value2), (value3, value4);

Q: Give an example of inserting data into 'Customers' table with specified columns
A: INSERT INTO Customers (CustomerName, City, Country) VALUES ('Cardinal', 'Stavanger', 'Norway');

Q: Adds new records to a table
A: What does the SQL INSERT INTO statement do?

Q: Can you insert values into all columns without naming them?
A: True

Q: INSERT INTO table_name (column1, column2) VALUES (value1, value2);
A: What is the syntax for inserting values into specified columns?

Q: The value is generated automatically
A: Why don't you insert a value for the auto-increment ID field?